package com.excesys.exsecs.energy.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.excesys.exsecs.energy.entity.WaterHourFlow;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface WaterHourFlowMapper extends BaseMapper<WaterHourFlow> {
    Double sumWaterList(@Param("timeValue") String timeValue,@Param("subzone") String subzone);

    List<Map<String, Object>> waterAnalyse(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("energyType") String energyType);

    Double sumWaterAllNumber(@Param("energyType") String energyType, @Param("timeValue") String timeValue,@Param("subzone") String subzone);

    //区间查询
    List<Map<String, Object>> waterDayAnalyse(@Param("startTime") String startTime,
                                              @Param("endTime") String endTime,
                                              @Param("energyType") String energyType);

    List<Map<String, Object>> waterHourAnalyse(@Param("startTime") String startTime,
                                               @Param("endTime") String endTime,
                                               @Param("energyType") String energyType);
}